Navicat allows you to create a batch job for setting schedule to execute at one regular interval. Batch job can be created for Query, Data Transfer, Data Synchronization, Import and Export from MySQL, Oracle, PostgreSQL, SQLite and SQL Server. You can define a list of actions to be performed within one batch job, either run it manually or at the specified time/periodically.
Just simply click to open an object pane for Schedule. A control-click displays the popup menu or using the object pane toolbar below, allowing you to create new, edit, open and delete the selected batch job/schedule.
Create Batch Job
To create a new batch job
- Select anywhere on the object pane.
- Click the
from the object pane toolbar.
or - Control-click and select New Batch Job from the popup menu.
- Edit batch job properties.
To create a new batch job with modification as one of the existing batch jobs
- Select the batch job for modifying in the object pane.
- Control-click and select the Design Batch Job from the popup menu.
or - Click the
from the object pane toolbar.
- Modify batch job properties.
- Click
Save As.
To duplicate an existing batch job
- Select the batch job for modifying in the object pane.
- Control-click and select the Duplicate Batch Job from the popup menu.
- The newly created batch job will be named as "batchjobname_copy".
To edit the existing batch job
- Select the batch job for editing in the object pane.
- Control-click and select the Design
Batch Job from the popup menu.
or - Click the
Design Batch Job from the object pane toolbar.
- Edit batch job properties.
To change the name of the batch job
- Select the batch job for editing in the object pane.
- Control-click and select the Rename from the popup menu.
Run Batch Job
To run a batch job
- Create a new batch job/open the existing one.
- Click
Run.
To run from Command Line
- Create and save profile.
- In terminal, type the command (see Command for details)
Delete Batch Job
To delete a batch job
- Select the batch job for deleting in the object pane.
- Control-click and select the Delete Batch Job from the popup menu.
or - Click the
from the object pane toolbar.
- Confirm deleting in the dialog window.
Convert Batch Job
To convert a batch job
- Control-click and select the Batch Job Converter from the popup menu in the object pane.
- Select the batch jobs.
- Set the convert options.
- Click Start.
Set Schedule
To set schedule to the batch job
- Create and save the batch job/open the existing one.
- Control-click and select the Setup Run Schedule from the popup menu.
or - Click the Schedule from the object pane toolbar.
or - Click the
Setup Run Schedule from the toolbar.
- Set your schedule of the batch job.
Hint: CmdLineJob.log stores all the operations executed, indicating success or failure during the schedule.
To show all set schedules
- In terminal, type the command (see Command for details)
Delete Schedule
To delete a schedule
- Select the scheduled batch job in the object pane.
- Control-click and select the Erase Schedule from the popup menu.
or - Click the
Erase Schedule from the toolbar.